from sqlalchemy import Column, Integer, String, Date
from .Base import (Base)

class Student(Base):
    __tablename__ = "student"

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    name = Column(String(100), nullable=False)
    gender = Column(String(10), nullable=False)
    id_card = Column(String(18), unique=True, nullable=False, index=True)
    birth_date = Column(Date)
    classroom_id = Column(Integer, index=True)
